One moment please...
 
Exact Financials   
 

CC_BAL

CC_BAL (acc_nr,cc,co,FY,period,balance_type,value,calc)

By using this function, you can include the balance of a cost center balance sheet accounts in the worksheet.

Example

CC_BAL(3000,WAREHOUSE,100,2002,12,1,1,1)

As a result of the above function, the debit balance of the cost center 'WAREHOUSE' is included in the financial year 2002 and period 12, based on the amounts entered in general ledger account 3000.

Note that a range of cost centers can be entered by separating the cost centers with a colon (:).

Example

CC_BAL(3000,ADMI:DIR,100,2004,6,1,1)

Returns the debit balance of all cost centers between 'ADMI' and 'DIR' in financial year 2004, period 6, on g/l account '3000'.

See also:

[Alphabetical overview of parameters]


Excel Add-in Manual > Contents > Functions > CC_BAL


     
 Main Category: Support Product Know How  Document Type: Support - On-line help
 Category: On-line help files  Security  level: All - 0
 Sub category: Details  Document ID: 18.314.649
 Assortment:  Date: 01-12-2008
 Release:  Attachment:
 Disclaimer